package com.wf.ew.common.utils;

import java.util.ArrayList;
import java.util.Arrays;
import java.util.List;

public class CreateTableUtil {

    private StringBuffer communitytable = new StringBuffer().append("\n" +
            "CREATE TABLE `t_#communityCode#_addressmatch`  (\n" +
            "  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',\n" +
            "  `addressType` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '地址类型',\n" +
            "  `nonstandardAddress` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '非标准地址',\n" +
            "  `standardAddress` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '标准地址',\n" +
            "  `createDate` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '创建日期',\n" +
            "  PRIMARY KEY (`id`) USING BTREE\n" +
            ") ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '地址匹配表' ROW_FORMAT = Dynamic;\n" +
            "\n" +
            "\n" +
            "CREATE TABLE `t_#communityCode#_bigpartycommittee`  (\n" +
            "  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',\n" +
            "  `companyname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '单位名称',\n" +
            "  `person` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '负责人',\n" +
            "  `tel` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '联系电话',\n" +
            "  `work` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '职位',\n" +
            "  `mailbox` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '邮箱',\n" +
            "  `isdelete` int(11) NULL DEFAULT 0 COMMENT '删除标记',\n" +
            "  `createtime` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '创建时间',\n" +
            "  `updatetime` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '修改时间',\n" +
            "  PRIMARY KEY (`id`) USING BTREE\n" +
            ") ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '大党委' ROW_FORMAT = Dynamic;\n" +
            "\n" +
            "CREATE TABLE `t_#communityCode#_building`  (\n" +
            "  `Id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'Id',\n" +
            "  `YardId` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT 'YardId',\n" +
            "  `BuildingShape` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '楼型',\n" +
            "  `BuildingNum` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '楼号',\n" +
            "  `UnitNum` int(11) NULL DEFAULT 0 COMMENT '总单元数',\n" +
            "  `FloorCount` int(8) NULL DEFAULT 0 COMMENT '总层数',\n" +
            "  `ElevatorCount` int(8) NULL DEFAULT 0 COMMENT '电梯数',\n" +
            "  `CreateDate` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '创建时间',\n" +
            "  `IsDelete` int(11) NULL DEFAULT 0 COMMENT '删除标记',\n" +
            "  `Remark` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '备注',\n" +
            "  `HouseCount` int(10) NULL DEFAULT NULL COMMENT '每层户数（沿用1.0）',\n" +
            "  `HouseNum` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '房号（沿用1.0）',\n" +
            "  `AllHouseCount` int(10) NULL DEFAULT NULL COMMENT '总户数（沿用1.0）',\n" +
            "  `BuildingName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '楼房名称',\n" +
            "  `ObjectId` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '图层id',\n" +
            "  `ConstructionAge` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',\n" +
            "  `BuildingArea` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',\n" +
            "  `BuildingLocation` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',\n" +
            "  `nameObjectId` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',\n" +
            "  `Developers` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '开发商',\n" +
            "  `BuildingType` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '楼房类别',\n" +
            "  `hasD` int(11) NULL DEFAULT 0 COMMENT '是否有地下',\n" +
            "  `buildingstate` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '楼型',\n" +
            "  `sort` int(11) NULL DEFAULT NULL COMMENT '排序',\n" +
            "  PRIMARY KEY (`Id`) USING BTREE\n" +
            ") ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '楼房' ROW_FORMAT = Dynamic;\n" +
            "\n" +
            "CREATE TABLE `t_#communityCode#_cancerousperson`  (\n" +
            "  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',\n" +
            "  `personId` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',\n" +
            "  `typesOfCancer` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '患何种癌',\n" +
            "  `remark` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '备注',\n" +
            "  PRIMARY KEY (`id`) USING BTREE\n" +
            ") ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '两癌人员' ROW_FORMAT = Dynamic;\n" +
            "\n" +
            "CREATE TABLE `t_#communityCode#_car`  (\n" +
            "  `Id` int(64) NOT NULL AUTO_INCREMENT COMMENT 'Id',\n" +
            "  `HouseholdId` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT 'HousehldId',\n" +
            "  `personName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '车主名',\n" +
            "  `CarType` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '车辆型号',\n" +
            "  `CarColor` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '颜色',\n" +
            "  `CarNumber` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '车牌号',\n" +
            "  `ParkingSpace` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '停车位',\n" +
            "  `RegisterTime` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '登记时间',\n" +
            "  `IsDelete` int(11) NULL DEFAULT 0 COMMENT '删除标记',\n" +
            "  `remark` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '备注',\n" +
            "  `telephone` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '电话',\n" +
            "  `createtime` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '创建时间',\n" +
            "  `updatetime` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '修改时间',\n" +
            "  `ownerType` int(5) NULL DEFAULT 1 COMMENT '车主类型：0，非本社区；1，非本社区',\n" +
            "  `ownerAddress` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '车主地址',\n" +
            "  PRIMARY KEY (`Id`) USING BTREE\n" +
            ") ENGINE = InnoDB AUTO_INCREMENT = 3619 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '车辆' ROW_FORMAT = Dynamic;\n" +
            "\n" +
            "CREATE TABLE `t_#communityCode#_certificate`  (\n" +
            "  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',\n" +
            "  `isUpDown` int(11) NULL DEFAULT 0 COMMENT '上下联标记',\n" +
            "  `title` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '证明标题',\n" +
            "  `organization` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '称谓',\n" +
            "  `NAME` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '证明人姓名',\n" +
            "  `address` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '居住地址',\n" +
            "  `householdaddress` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '户籍地址',\n" +
            "  `idCard` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '证明人证件号码',\n" +
            "  `age` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '证明人年龄',\n" +
            "  `sex` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '证明人性别',\n" +
            "  `ending` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '证明结尾',\n" +
            "  `templatePurpose` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '证明用途',\n" +
            "  `templateDate` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '落款日期',\n" +
            "  `organizationName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '落款单位',\n" +
            "  `instructions` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '备注',\n" +
            "  `templateUrl` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '证明URL',\n" +
            "  `producer` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '创建人',\n" +
            "  `productionDate` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '创建日期',\n" +
            "  `effectiveness` int(5) NULL DEFAULT 1 COMMENT '有效性',\n" +
            "  `content` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '补充内容',\n" +
            "  `templateid` int(11) NULL DEFAULT NULL COMMENT '模板id',\n" +
            "  `code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,\n" +
            "  PRIMARY KEY (`id`) USING BTREE\n" +
            ") ENGINE = InnoDB AUTO_INCREMENT = 638 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '证明表' ROW_FORMAT = Dynamic;\n" +
            "\n").append(
            "CREATE TABLE `t_#communityCode#_civilaffair`  (\n" +
            "  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',\n" +
            "  `communityId` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '社区Id',\n" +
            "  `idCardType` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '证件类型',\n" +
            "  `sex` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '性别',\n" +
            "  `idCard` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '申请人证件号',\n" +
            "  `applicantName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '声请人姓名',\n" +
            "  `applicantPhone` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '申请人电话',\n" +
            "  `applicantAddress` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '申请人住址',\n" +
            "  `householdcategory` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '户籍类别',\n" +
            "  `householdaddress` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '户籍地址',\n" +
            "  `applicationDate` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '申请日期',\n" +
            "  `acceptance` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '受理人',\n" +
            "  `processingState` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '处理状态',\n" +
            "  `acceptedDate` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '受理日期',\n" +
            "  `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '备注',\n" +
            "  `replyContent` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '回馈内容',\n" +
            "  `civilAffairsType` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '民政事务办理事项',\n" +
            "  PRIMARY KEY (`id`) USING BTREE\n" +
            ") ENGINE = InnoDB AUTO_INCREMENT = 27 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '民政事务表' ROW_FORMAT = Dynamic;\n" +
            "\n" +
            "CREATE TABLE `t_#communityCode#_communityprofile`  (\n" +
            "  `id` int(11) NOT NULL AUTO_INCREMENT,\n" +
            "  `headline` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '概况标题',\n" +
            "  `introduce` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '概况内容',\n" +
            "  PRIMARY KEY (`id`) USING BTREE\n" +
            ") ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;\n" +
            "\n" +
            "CREATE TABLE `t_#communityCode#_courtyard`  (\n" +
            "  `id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'id',\n" +
            "  `CommunityId` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '社区',\n" +
            "  `Yard` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '楼院',\n" +
            "  `Remark` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '备注',\n" +
            "  `CreateDate` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '创建时间',\n" +
            "  `IsDelete` int(11) NULL DEFAULT 0 COMMENT '删除标记',\n" +
            "  `yardReferred` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '楼院简称（用于门禁匹配）',\n" +
            "  PRIMARY KEY (`id`) USING BTREE\n" +
            ") ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '楼院' ROW_FORMAT = Dynamic;\n" +
            "\n" +
            "\n" +
            "CREATE TABLE `t_#communityCode#_culturaleducation`  (\n" +
            "  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',\n" +
            "  `communityId` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '社区Id',\n" +
            "  `idCardType` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '证件类型',\n" +
            "  `idCard` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '申请人证件号',\n" +
            "  `applicantName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '声请人姓名',\n" +
            "  `applicantPhone` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '申请人电话',\n" +
            "  `applicantAddress` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '申请人住址',\n" +
            "  `householdcategory` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '户籍类别',\n" +
            "  `householdaddress` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '户籍地址',\n" +
            "  `applicationDate` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '申请日期',\n" +
            "  `acceptance` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '受理人',\n" +
            "  `processingState` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '处理状态',\n" +
            "  `acceptedDate` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '受理日期',\n" +
            "  `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '备注',\n" +
            "  `replyContent` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '回馈内容',\n" +
            "  `cultureEducation` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文教事务办理事项',\n" +
            "  PRIMARY KEY (`id`) USING BTREE\n" +
            ") ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '文教办事表' ROW_FORMAT = Dynamic;\n" +
            "\n" +
            "CREATE TABLE `t_#communityCode#_disabled`  (\n" +
            "  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',\n" +
            "  `communityId` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '社区Id',\n" +
            "  `idCardType` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '证件类型',\n" +
            "  `idCard` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '申请人证件号',\n" +
            "  `applicantName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '声请人姓名',\n" +
            "  `applicantPhone` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '申请人电话',\n" +
            "  `applicantAddress` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '申请人住址',\n" +
            "  `householdcategory` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '户籍类别',\n" +
            "  `householdaddress` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '户籍地址',\n" +
            "  `injuryLevel` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '伤残等级',\n" +
            "  `injuryType` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '伤残类别',\n" +
            "  `discountType` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '优惠政策',\n" +
            "  `applicationDate` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '申请日期',\n" +
            "  `acceptance` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '受理人',\n" +
            "  `processingState` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '处理状态',\n" +
            "  `acceptedDate` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '受理日期',\n" +
            "  `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '备注',\n" +
            "  `replyContent` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '回馈内容',\n" +
            "  `oneself` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '自理残疾人',\n" +
            "  `disabledType` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,\n" +
            "  PRIMARY KEY (`id`) USING BTREE\n" +
            ") ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '残疾人表' ROW_FORMAT = Dynamic;\n" +
            "\n" +
            "\n" +
            "CREATE TABLE `t_#communityCode#_disabledperson`  (\n" +
            "  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',\n" +
            "  `personId` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '人员主表ID',\n" +
            "  `disableCard` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '残疾证号',\n" +
            "  `disableType` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '残疾类别',\n" +
            "  `disableLevel` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '残疾等级',\n" +
            "  `isSevere` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',\n" +
            "  `createDate` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '创建日期',\n" +
            "  `remark` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '备注',\n" +
            "  `linkMan` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '紧急联系人',\n" +
            "  `linkPhone` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '紧急联系人',\n" +
            "  `subsidyContet` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '补贴内容',\n" +
            "  `subsidyMoney` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '补贴金额',\n" +
            "  `cardAccount` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '一卡通账号',\n" +
            "  `cardDate` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '发卡日期',\n" +
            "  `status` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '状态',\n" +
            "  `licensingDate` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '领证时间',\n" +
            "  `activeSituation` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '参加活动情况',\n" +
            "  `lnsuranceSituation` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '保险情况',\n" +
            "  `childSituation` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '子女情况',\n" +
            "  `fileNum` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '档案号',\n" +
            "  PRIMARY KEY (`id`) USING BTREE\n" +
            ") ENGINE = InnoDB AUTO_INCREMENT = 58 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '残疾人扩展信息表' ROW_FORMAT = Dynamic;\n" +
            "\n").append(
            "\n" +
            "CREATE TABLE `t_#communityCode#_dzb`  (\n" +
            "  `id` int(11) NOT NULL AUTO_INCREMENT,\n" +
            "  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',\n" +
            "  `type` int(11) NULL DEFAULT 0,\n" +
            "  `status` int(11) NULL DEFAULT 0,\n" +
            "  `objectId` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',\n" +
            "  `nameObjectId` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',\n" +
            "  `iconObjectId` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',\n" +
            "  `location` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',\n" +
            "  `dzbtype` int(11) NULL DEFAULT 0 COMMENT '党支部类型',\n" +
            "  PRIMARY KEY (`id`) USING BTREE\n" +
            ") ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;\n" +
            "\n" +
            "\n" +
            "CREATE TABLE `t_#communityCode#_familyadvstateext`  (\n" +
            "  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',\n" +
            "  `personid` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '与人员表id关联',\n" +
            "  `workTime` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '从事计生工作时间',\n" +
            "  `workUnit` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '工作单位',\n" +
            "  `workType` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '专兼职 01专职 02兼职',\n" +
            "  `createTime` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '创建时间',\n" +
            "  `remark` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '备注',\n" +
            "  PRIMARY KEY (`id`) USING BTREE\n" +
            ") ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;\n" +
            "\n" +
            "\n" +
            "CREATE TABLE `t_#communityCode#_floatingpopulation`  (\n" +
            "  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',\n" +
            "  `personId` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',\n" +
            "  `typeOfResidence` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '居住类型',\n" +
            "  `reasonsForBeijing` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '来京原因',\n" +
            "  `remark` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '备注',\n" +
            "  `floatingpopulationIdCardType` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '办理证件',\n" +
            "  `registrationDate` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '登记日期',\n" +
            "  PRIMARY KEY (`id`) USING BTREE,\n" +
            "  INDEX `idx_fp_pid_#communityCode#`(`personId`) USING BTREE\n" +
            ") ENGINE = InnoDB AUTO_INCREMENT = 505 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '流动人口' ROW_FORMAT = Dynamic;\n" +
            "\n" +
            "\n" +
            "CREATE TABLE `t_#communityCode#_history`  (\n" +
            "  `Id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'Id',\n" +
            "  `HistoryObject` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '历史对象',\n" +
            "  `ObjectType` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '对象类型',\n" +
            "  `HaveIcon` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '是否显示图标',\n" +
            "  `Icon` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '显示图标类型',\n" +
            "  `Time` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '历史留存日期',\n" +
            "  PRIMARY KEY (`Id`) USING BTREE\n" +
            ") ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '历史记录表' ROW_FORMAT = Dynamic;\n" +
            "\n" +
            "\n" +
            "CREATE TABLE `t_#communityCode#_house`  (\n" +
            "  `Id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'Id',\n" +
            "  `BuildingId` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT 'BuildingId',\n" +
            "  `HouseNumber` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '房间号',\n" +
            "  `HouseAddress` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '房间地址',\n" +
            "  `HouseState` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'ZGFW' COMMENT '房间状态',\n" +
            "  `Unit` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '单元',\n" +
            "  `Floor` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '楼层',\n" +
            "  `Remark` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注',\n" +
            "  `HouseStructure` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '户型结构',\n" +
            "  `Area` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '面积',\n" +
            "  `IsDelete` int(11) NULL DEFAULT 0 COMMENT '删除标记',\n" +
            "  `CreateTime` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '创建日期',\n" +
            "  `OwnerName` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '房主姓名',\n" +
            "  `OwnerSex` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '房主性别',\n" +
            "  `OwnerPhone` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '电话',\n" +
            "  `OwnerIDcard` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '证件号',\n" +
            "  `room` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '室',\n" +
            "  `hall` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '厅',\n" +
            "  `updateTime` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '更新时间',\n" +
            "  PRIMARY KEY (`Id`) USING BTREE\n" +
            ") ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '房间表' ROW_FORMAT = Dynamic;\n" +
            "\n").append(
            "\n" +
            "CREATE TABLE `t_#communityCode#_house_bak`  (\n" +
            "  `Id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'Id',\n" +
            "  `BuildingId` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT 'BuildingId',\n" +
            "  `HouseNumber` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '房间号',\n" +
            "  `HouseAddress` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '房间地址',\n" +
            "  `HouseState` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '房间状态',\n" +
            "  `Unit` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '单元',\n" +
            "  `Floor` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '楼层',\n" +
            "  `Remark` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '备注',\n" +
            "  `HouseStructure` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '户型结构',\n" +
            "  `Area` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '面积',\n" +
            "  `IsDelete` int(11) NULL DEFAULT 0 COMMENT '删除标记',\n" +
            "  `CreateTime` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '创建日期',\n" +
            "  `OwnerName` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '房主姓名',\n" +
            "  `OwnerSex` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '房主性别',\n" +
            "  `OwnerPhone` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '电话',\n" +
            "  `OwnerIDcard` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '证件号'\n" +
            ") ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;\n" +
            "\n" +
            "\n" +
            "CREATE TABLE `t_#communityCode#_house_img`  (\n" +
            "  `id` int(11) NOT NULL AUTO_INCREMENT,\n" +
            "  `houseid` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT 'houseid',\n" +
            "  `imgid` int(11) NULL DEFAULT NULL COMMENT 'imgid',\n" +
            "  PRIMARY KEY (`id`) USING BTREE\n" +
            ") ENGINE = InnoDB AUTO_INCREMENT = 57 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;\n" +
            "\n" +
            "\n" +
            "CREATE TABLE `t_#communityCode#_household`  (\n" +
            "  `Id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'Id',\n" +
            "  `HouseId` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT 'HouseId',\n" +
            "  `Name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '户名',\n" +
            "  `HouseholdType` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'JT' COMMENT '住户类型',\n" +
            "  `HouseLinkMan` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '住户联系人',\n" +
            "  `HouesTelephone` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '住户电话',\n" +
            "  `Remark` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '备注',\n" +
            "  `UpdateTime` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '最后更新时间',\n" +
            "  `CreateTime` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '创建时间',\n" +
            "  `IsDelete` int(11) NULL DEFAULT 0 COMMENT '删除标记',\n" +
            "  `homeownerrelationship` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '与房主关系',\n" +
            "  `data_update_time` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '数据最后更新时间',\n" +
            "  PRIMARY KEY (`Id`) USING BTREE,\n" +
            "  INDEX `idx_hh_hid_#communityCode#`(`HouseId`) USING BTREE\n" +
            ") ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '住户表' ROW_FORMAT = Dynamic;\n" +
            "\n" +
            "\n" +
            "CREATE TABLE `t_#communityCode#_household_company`  (\n" +
            "  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',\n" +
            "  `householdid` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT 'householdid',\n" +
            "  `ZZJGMC` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '组织机构名称',\n" +
            "  `ZZJGYGSL` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '组织机构员工数量',\n" +
            "  `ZZJGDM` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '组织机构代码',\n" +
            "  `ZZJGLX` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '组织机构父类型',\n" +
            "  `ZZJGZLX` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '组织机构子类型',\n" +
            "  `FRDB` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '法定代表人',\n" +
            "  `FRDBDH` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '法定代表人电话',\n" +
            "  `FZR` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '负责人',\n" +
            "  `FZRDH` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '负责人电话',\n" +
            "  `DKGLKS` int(11) NULL DEFAULT NULL COMMENT '对口管理科室',\n" +
            "  `JYMJ` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '经营面积',\n" +
            "  `YTHHY` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '行业和用途',\n" +
            "  `RYGC` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '人员构成',\n" +
            "  `FRSFZ` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '法人身份证',\n" +
            "  `FRSFZtwo` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '法人身份证2',\n" +
            "  `ZZJGDMZ` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '组织机构代码证',\n" +
            "  `ZZJGDMZtwo` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '组织机构代码证2',\n" +
            "  `YYZZ` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '营业执照',\n" +
            "  `YYZZtwo` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '营业执照2',\n" +
            "  `QTtwo` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '其他证件2',\n" +
            "  `QT` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '其他证件',\n" +
            "  `TJZP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '添加照片',\n" +
            "  `TJZPtwo` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '添加照片2',\n" +
            "  `ZZJGDZ` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '组织机构地址',\n" +
            "  `CLtime` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '成立时间',\n" +
            "  `objectId` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT 'GisId',\n" +
            "  PRIMARY KEY (`id`) USING BTREE\n" +
            ") ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;\n" +
            "\n" +
            "\n" +
            "CREATE TABLE `t_#communityCode#_household_drom`  (\n" +
            "  `UnitName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '单位名称',\n" +
            "  `UnitLinkMan` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '单位联系人',\n" +
            "  `UnitPhone` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '单位电话',\n" +
            "  `UnitManCount` int(11) NULL DEFAULT NULL COMMENT '单位宿舍人数',\n" +
            "  `UnitMoveInTime` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '单位入住时间',\n" +
            "  `householdid` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT 'householdid',\n" +
            "  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',\n" +
            "  PRIMARY KEY (`id`) USING BTREE\n" +
            ") ENGINE = InnoDB AUTO_INCREMENT = 37 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;\n" +
            "\n" +
            "\n" +
            "CREATE TABLE `t_#communityCode#_household_person`  (\n" +
            "  `id` int(11) NOT NULL AUTO_INCREMENT,\n" +
            "  `householdid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',\n" +
            "  `personid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',\n" +
            "  `ReliationShip` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '成员关系',\n" +
            "  `HouseholdStatus` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '户籍状态',\n" +
            "  PRIMARY KEY (`id`) USING BTREE,\n" +
            "  INDEX `idx_hp_pid_#communityCode#`(`personid`) USING BTREE,\n" +
            "  INDEX `idx_hp_hid_#communityCode#`(`householdid`) USING BTREE\n" +
            ") ENGINE = InnoDB AUTO_INCREMENT = 16971 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;\n" +
            "\n" +
            "\n" +
            "CREATE TABLE `t_#communityCode#_images`  (\n" +
            "  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',\n" +
            "  `imgname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '图片名',\n" +
            "  `imgurl` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '路径',\n" +
            "  PRIMARY KEY (`id`) USING BTREE\n" +
            ") ENGINE = InnoDB AUTO_INCREMENT = 35 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;\n" +
            "\n").append(
            "\n" +
            "CREATE TABLE `t_#communityCode#_importrecord`  (\n" +
            "  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',\n" +
            "  `nonstandardData` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '无法导入数据',\n" +
            "  `createDate` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '导入日期',\n" +
            "  PRIMARY KEY (`id`) USING BTREE\n" +
            ") ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '导入记录表' ROW_FORMAT = Dynamic;\n" +
            "\n" +
            "\n" +
            "CREATE TABLE `t_#communityCode#_installation`  (\n" +
            "  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',\n" +
            "  `parentType` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '父类别',\n" +
            "  `Type` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '设施类别',\n" +
            "  `DeviceName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '设备名称',\n" +
            "  `ObjectId` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',\n" +
            "  `CommunityId` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',\n" +
            "  `Number` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '数量(社团/设施)',\n" +
            "  `GroupBy` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '人员构成',\n" +
            "  `CreateTime` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '创建时间',\n" +
            "  `Yard` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '楼院',\n" +
            "  `BuildingNum` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '楼号',\n" +
            "  `Place` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '所在处',\n" +
            "  `Location` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '位置',\n" +
            "  `Company` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '单位名称',\n" +
            "  `office` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '管理科室',\n" +
            "  `Leader` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '负责人',\n" +
            "  `phoneNum` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',\n" +
            "  `ManagePerson` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '管理人',\n" +
            "  `Measure` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '措施',\n" +
            "  `Remark` varchar(600) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',\n" +
            "  PRIMARY KEY (`id`) USING BTREE\n" +
            ") ENGINE = InnoDB AUTO_INCREMENT = 32 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;\n" +
            "\n" +
            "CREATE TABLE `t_#communityCode#_label`  (\n" +
            "  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',\n" +
            "  `labelCode` int(11) NULL DEFAULT NULL COMMENT '编号',\n" +
            "  `labelName` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '标签名',\n" +
            "  PRIMARY KEY (`id`) USING BTREE\n" +
            ") ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '标签' ROW_FORMAT = Dynamic;\n" +
            "\n" +
            "\n" +
            "CREATE TABLE `t_#communityCode#_meetingrecord`  (\n" +
            "  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',\n" +
            "  `MeetTitle` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '会议标题',\n" +
            "  `MeetDate` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '会议时间',\n" +
            "  `Content` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '内容',\n" +
            "  `Person` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '参与人员',\n" +
            "  `Address` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '会议地点',\n" +
            "  `Remark` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '备注',\n" +
            "  `isdelete` int(11) NULL DEFAULT 0 COMMENT '删除标记',\n" +
            "  `type` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '类型',\n" +
            "  `createtime` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '创建时间',\n" +
            "  `updatetime` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '修改时间',\n" +
            "  `photo1` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '相关照片1',\n" +
            "  `photo2` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '相关照片2',\n" +
            "  `photo3` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '相关照片3',\n" +
            "  PRIMARY KEY (`id`) USING BTREE\n" +
            ") ENGINE = InnoDB AUTO_INCREMENT = 20 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '会议记录' ROW_FORMAT = Dynamic;\n" +
            "\n" +
            "\n" +
            "CREATE TABLE `t_#communityCode#_nonpublicpartybranch`  (\n" +
            "  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',\n" +
            "  `companyname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '组织名称',\n" +
            "  `scale` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '规模以上或以下',\n" +
            "  `kind` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '类别',\n" +
            "  `address` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '单位地址',\n" +
            "  `lawperson` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '法人代表',\n" +
            "  `tel` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '联系方式',\n" +
            "  `personpolitical` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '法人代表政治面貌',\n" +
            "  `buyaddress` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '生产经营主要地',\n" +
            "  `org` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '登记注册机关所在地',\n" +
            "  `employeenum` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '员工数',\n" +
            "  `partynum` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '党员数',\n" +
            "  `isBuildPartyOrg` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '是否建立党组织',\n" +
            "  `isBuildGroupOrg` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '是否建立群团组织',\n" +
            "  `partyguide` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '配备党建指导员',\n" +
            "  `remark` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '备注',\n" +
            "  `isdelete` int(11) NULL DEFAULT 0 COMMENT '删除标记',\n" +
            "  `createtime` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '创建时间',\n" +
            "  `updatetime` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '修改时间',\n" +
            "  PRIMARY KEY (`id`) USING BTREE\n" +
            ") ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '非公联合党支部' ROW_FORMAT = Dynamic;\n" +
            "\n" +
            "CREATE TABLE `t_#communityCode#_notelabel_person`  (\n" +
            "  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',\n" +
            "  `label` int(11) NULL DEFAULT NULL COMMENT '标签表id',\n" +
            "  `personid` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '人员表id',\n" +
            "  PRIMARY KEY (`id`) USING BTREE\n" +
            ") ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;\n" +
            "\n" +
            "\n" +
            "CREATE TABLE `t_#communityCode#_oldmanstateext`  (\n" +
            "  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',\n" +
            "  `PersonId` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT 'PersonId',\n" +
            "  `LinkMan` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '紧急联系人',\n" +
            "  `Ship` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '与老人关系',\n" +
            "  `Phone` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '紧急联系人电话',\n" +
            "  `MedicationHistory` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '用药历史',\n" +
            "  `PhysicalCondition` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '身体状况',\n" +
            "  `livingCondition` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '居住状况',\n" +
            "  `medicalSecurity` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '老年人医保类型',\n" +
            "  `selfcare` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '老年人生活自理情况',\n" +
            "  `economicSource` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '老年人经济来源',\n" +
            "  `pensionLevel` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '养老金水平',\n" +
            "  `residentialType` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '老年人小区类型',\n" +
            "  `propertyType` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '房产类型',\n" +
            "  `remark` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '备注',\n" +
            "  `createDate` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '创建日期',\n" +
            "  `phoneType` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '手机类型',\n" +
            "  `broadbandStatus` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '宽带是否开通',\n" +
            "  PRIMARY KEY (`id`) USING BTREE\n" +
            ") ENGINE = InnoDB AUTO_INCREMENT = 569 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '人员状态扩展信息（老年人）' ROW_FORMAT = Dynamic;\n" +
            "\n").append(
            "CREATE TABLE `t_#communityCode#_partygrade`  (\n" +
            "  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',\n" +
            "  `NAME` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '名称',\n" +
            "  `starttime` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '开始时间',\n" +
            "  `endtime` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '结束时间',\n" +
            "  `createtime` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '创建时间',\n" +
            "  `updatetime` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '修改时间',\n" +
            "  PRIMARY KEY (`id`) USING BTREE\n" +
            ") ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '党委届次' ROW_FORMAT = Dynamic;\n" +
            "\n" +
            "\n" +
            "CREATE TABLE `t_#communityCode#_partymember`  (\n" +
            "  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',\n" +
            "  `name` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '姓名',\n" +
            "  `Idcard` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '身份证号',\n" +
            "  `Phone` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '联系方式',\n" +
            "  `Sex` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '性别',\n" +
            "  `BornDate` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '出生日期',\n" +
            "  `Age` int(4) NULL DEFAULT NULL COMMENT '年龄',\n" +
            "  `JoinPartTime` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '入党日期',\n" +
            "  `Type` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '党员类别',\n" +
            "  `State` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '党员状态',\n" +
            "  `Address` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '居住地址',\n" +
            "  `TimeOfPay` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '党费交至时间',\n" +
            "  `TransitTime` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '转入时间',\n" +
            "  `Education` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '文化程度',\n" +
            "  `dzb` int(11) NULL DEFAULT 0 COMMENT '所属党支部',\n" +
            "  `RetirementTime` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '退休时间',\n" +
            "  `Remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '备注',\n" +
            "  `IsDelete` int(11) NULL DEFAULT 0 COMMENT '删除标记',\n" +
            "  `WorkingTime` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '工作时间',\n" +
            "  `job` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '工作',\n" +
            "  `isLive` int(11) NULL DEFAULT 0 COMMENT '是否在本社区居住',\n" +
            "  `personId` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '人员id',\n" +
            "  `homeTel` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',\n" +
            "  `nation` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '民族',\n" +
            "  `retirementUnit` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',\n" +
            "  `partymemberage` int(4) NULL DEFAULT NULL COMMENT '党龄',\n" +
            "  `createtime` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '创建时间',\n" +
            "  `updatetime` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '修改时间',\n" +
            "  `lostPartymember` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '是否为失联党员',\n" +
            "  `lostDate` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '失去联系日期',\n" +
            "  `mobilePartymember` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '是否为流动党员 是1 否 0',\n" +
            "  `outflow` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '外出流向',\n" +
            "  `outtimeofpay` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '转出时党费交至时间',\n" +
            "  `dues` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '应收党费（月）',\n" +
            "  `outoftime` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '转出时间',\n" +
            "  `joinworktime` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '参加工作时间',\n" +
            "  `graduation` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '毕业院校',\n" +
            "  `workUnit` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '工作单位',\n" +
            "  PRIMARY KEY (`id`) USING BTREE\n" +
            ") ENGINE = InnoDB AUTO_INCREMENT = 213 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;\n" +
            "\n" +
            "\n" +
            "CREATE TABLE `t_#communityCode#_partymembercommittee`  (\n" +
            "  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',\n" +
            "  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '姓名',\n" +
            "  `inaugurationtime` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '上任时间',\n" +
            "  `departuretime` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '卸任时间',\n" +
            "  `grade` int(11) NULL DEFAULT 0 COMMENT '届',\n" +
            "  `position` int(11) NULL DEFAULT 0 COMMENT '职位',\n" +
            "  `dzb` int(11) NULL DEFAULT 0 COMMENT '党支部',\n" +
            "  `remark` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '备注',\n" +
            "  `isdelete` int(11) NULL DEFAULT 0 COMMENT '删除标记',\n" +
            "  `createtime` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '创建时间',\n" +
            "  `updatetime` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '修改时间',\n" +
            "  `liveaddress` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '家庭住址',\n" +
            "  PRIMARY KEY (`id`) USING BTREE\n" +
            ") ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '党委历史表' ROW_FORMAT = Dynamic;\n" +
            "\n" +
            "\n" +
            "CREATE TABLE `t_#communityCode#_partymemberdevelopment`  (\n" +
            "  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',\n" +
            "  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '姓名',\n" +
            "  `dzb` int(11) NULL DEFAULT 0 COMMENT '党支部',\n" +
            "  `sex` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '性别',\n" +
            "  `nation` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '民族',\n" +
            "  `idcard` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '身份证',\n" +
            "  `tel` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '电话',\n" +
            "  `identity` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '身份',\n" +
            "  `address` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '地址',\n" +
            "  `personone` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '推荐人员1',\n" +
            "  `persontwo` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '推荐人员2',\n" +
            "  `trainingrecord` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '培养记录',\n" +
            "  `createdate` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '创建时间',\n" +
            "  `isdelete` int(11) NULL DEFAULT 0 COMMENT '删除标记',\n" +
            "  `createtime` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '创建时间',\n" +
            "  `updatetime` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '修改时间',\n" +
            "  PRIMARY KEY (`id`) USING BTREE\n" +
            ") ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '党员发展与培养' ROW_FORMAT = Dynamic;\n" +
            "\n").append(
            "\n" +
            "CREATE TABLE `t_#communityCode#_partymemberrolloutrecord`  (\n" +
            "  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',\n" +
            "  `Name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '姓名',\n" +
            "  `Idcard` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '身份证号',\n" +
            "  `Phone` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '联系方式',\n" +
            "  `Sex` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '性别',\n" +
            "  `BornDate` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '出生日期',\n" +
            "  `Age` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '年龄',\n" +
            "  `JoinPartTime` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '入党日期',\n" +
            "  `PartMemberType` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '党员类型',\n" +
            "  `PartMemberState` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '党员状态',\n" +
            "  `dzb` int(11) NULL DEFAULT 0 COMMENT '所属党支部',\n" +
            "  `LiveAddress` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '居住地址',\n" +
            "  `MembershipDuesDate` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '转出党费交至时间',\n" +
            "  `TransitTime` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '转入时间',\n" +
            "  `Education` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '文化程度',\n" +
            "  `WorkingTime` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '工作时间',\n" +
            "  `RetirementTime` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '退休时间',\n" +
            "  `IntoOut` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '转入/转出',\n" +
            "  `Receipt` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '回馈',\n" +
            "  `acceptman` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '受理人',\n" +
            "  `acceptTime` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '受理时间',\n" +
            "  `state` int(4) NULL DEFAULT 0 COMMENT '受理状态',\n" +
            "  `applyTime` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '申请时间',\n" +
            "  `remark` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '备注',\n" +
            "  `outTime` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '转出时间',\n" +
            "  `oldorganization` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '原党组织',\n" +
            "  `neworganization` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '接收党组织',\n" +
            "  `introduceTime` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '介绍信有效期',\n" +
            "  `createtime` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '创建时间',\n" +
            "  `updatetime` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '修改时间',\n" +
            "  `lostPartymember` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '是否为失联党员',\n" +
            "  `lostDate` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '失去联系日期',\n" +
            "  `mobilePartymember` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '是否为流动党员',\n" +
            "  `outflow` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '外出流向',\n" +
            "  `dues` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '应收党费（月）',\n" +
            "  `nation` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '民族',\n" +
            "  PRIMARY KEY (`id`) USING BTREE\n" +
            ") ENGINE = InnoDB AUTO_INCREMENT = 17 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;\n" +
            "\n" +
            "\n" +
            "CREATE TABLE `t_#communityCode#_partyposition`  (\n" +
            "  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',\n" +
            "  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '名称',\n" +
            "  `sort` int(11) NULL DEFAULT 0 COMMENT '排序',\n" +
            "  PRIMARY KEY (`id`) USING BTREE\n" +
            ") ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '党委职位表' ROW_FORMAT = Dynamic;\n" +
            "\n" +
            "\n" +
            "CREATE TABLE `t_#communityCode#_person`  (\n" +
            "  `Id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'Id',\n" +
            "  `AddressCode` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '编号',\n" +
            "  `Name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '姓名',\n" +
            "  `Sex` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '性别',\n" +
            "  `Nation` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '民族',\n" +
            "  `ZJLX` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '证件类型',\n" +
            "  `IdCard` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '证件号码',\n" +
            "  `PoliticalStatus` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '政治面貌',\n" +
            "  `Education` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '文化程度',\n" +
            "  `WorkOrSchool` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '工作单位或学校',\n" +
            "  `Telephone` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '联系方式',\n" +
            "  `HouseholdCategory` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '户籍类别',\n" +
            "  `HouseholdAddress` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '户籍地址',\n" +
            "  `LiveAddress1` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '居住地址1',\n" +
            "  `LiveAddress2` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '居住地址2',\n" +
            "  `LiveAddress3` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '居住地址3',\n" +
            "  `LiveAddress4` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '居住地址4',\n" +
            "  `LiveAddress5` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '居住地址5',\n" +
            "  `age` int(11) NULL DEFAULT NULL COMMENT '年龄',\n" +
            "  `BornDate` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '出生日期',\n" +
            "  `Remark` varchar(600) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',\n" +
            "  `DataFrom` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '数据来源',\n" +
            "  `CreateTime` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '创建时间',\n" +
            "  `UpdateTime` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '最后更新时间',\n" +
            "  `IsDelete` int(11) NULL DEFAULT 0 COMMENT '删除标记',\n" +
            "  `deadTime` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '死亡时间',\n" +
            "  `notMoveAccountReason` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '没迁出户口原因',\n" +
            "  `country` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '国家（地区）',\n" +
            "  `fixQhone` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '固话',\n" +
            "  `other` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '手机号或固话或其他',\n" +
            "  `personphoto` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '人员头像',\n" +
            "  `idcardPositivephoto` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '身份证正面照片',\n" +
            "  `idcardbackphoto` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '身份证背面照片',\n" +
            "  `is_owner` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '是否房主0不是1是',\n" +
            "  `live_type` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '居住类型1常住2暂住',\n" +
            "  `residentid` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '守望门禁人员id',\n" +
            "  PRIMARY KEY (`Id`) USING BTREE\n" +
            ") ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '人员表' ROW_FORMAT = Dynamic;\n" +
            "\n" +
            "\n" +
            "CREATE TABLE `t_#communityCode#_person_ext`  (\n" +
            "  `Id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Id',\n" +
            "  `PersonId` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT 'PersonId',\n" +
            "  `MaritalStatus` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '婚姻状况',\n" +
            "  `YHFL` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '已婚分类',\n" +
            "  `Religious` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '宗教信仰',\n" +
            "  `Health` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '健康状况',\n" +
            "  `CYZK` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '从业状况',\n" +
            "  `Profession` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '职业',\n" +
            "  `BloodType` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '血型',\n" +
            "  `BYQK` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '兵役情况',\n" +
            "  `SHJZ` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '社会兼职',\n" +
            "  `gzdw` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '工作单位',\n" +
            "  `SpecialHobby` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '兴趣爱好',\n" +
            "  `childAmount` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '子女状况',\n" +
            "  `medicalType` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '医疗保险类型',\n" +
            "  `foreignMarriage` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '是否涉外婚',\n" +
            "  `marriageDate` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '结婚日期',\n" +
            "  `height` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '身高',\n" +
            "  `guardianName` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '监护人姓名',\n" +
            "  `quardianIdCard` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '监护人身份证号',\n" +
            "  `guardianship` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '监护关系',\n" +
            "  PRIMARY KEY (`Id`) USING BTREE\n" +
            ") ENGINE = InnoDB AUTO_INCREMENT = 16883 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '人员扩展信息表' ROW_FORMAT = Dynamic;\n" +
            "\n" +
            "\n" +
            "CREATE TABLE `t_#communityCode#_person_grid`  (\n" +
            "  `personid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',\n" +
            "  `grid_id` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',\n" +
            "  `grid_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',\n" +
            "  `village_id` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',\n" +
            "  `village_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',\n" +
            "  `town_id` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',\n" +
            "  `town_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',\n" +
            "  PRIMARY KEY (`personid`) USING BTREE\n" +
            ") ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;\n" +
            "\n").append(
            "\n" +
            "CREATE TABLE `t_#communityCode#_person_history`  (\n" +
            "  `Id` int(64) NOT NULL AUTO_INCREMENT COMMENT 'Id',\n" +
            "  `operateDate` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '操作日期',\n" +
            "  `operateType` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '操作类型（0/1代表入/出）',\n" +
            "  `operaterId` int(11) NULL DEFAULT 0 COMMENT '操作人员Id',\n" +
            "  `communityId` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '社区Id',\n" +
            "  `houseId` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '房间Id',\n" +
            "  `houseName` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '房间名称',\n" +
            "  `AddressCode` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '编号',\n" +
            "  `ReliationShip` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '成员关系',\n" +
            "  `personId` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '人员Id',\n" +
            "  `Name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '姓名',\n" +
            "  `Sex` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '性别',\n" +
            "  `Nation` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '民族',\n" +
            "  `ZJLX` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '证件类型',\n" +
            "  `IdCard` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '证件号码',\n" +
            "  `PoliticalStatus` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '政治面貌',\n" +
            "  `Education` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '文化程度',\n" +
            "  `WorkOrSchool` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '工作单位或学校',\n" +
            "  `Telephone` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '联系方式',\n" +
            "  `HouseholdCategory` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '户籍类别',\n" +
            "  `HouseholdStatus` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '户籍状态',\n" +
            "  `HouseholdAddress` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '户籍地址',\n" +
            "  `LiveAddress1` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '居住地址1',\n" +
            "  `LiveAddress2` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '居住地址2',\n" +
            "  `LiveAddress3` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '居住地址3',\n" +
            "  `LiveAddress4` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '居住地址4',\n" +
            "  `LiveAddress5` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '居住地址5',\n" +
            "  `Age` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '年龄',\n" +
            "  `BornDate` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '出生日期',\n" +
            "  `Remark` varchar(600) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',\n" +
            "  `DataFrom` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '数据来源',\n" +
            "  `CreateTime` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '创建时间',\n" +
            "  `UpdateTime` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '最后更新时间',\n" +
            "  `IsDelete` int(11) NULL DEFAULT 0 COMMENT '删除标记',\n" +
            "  `deadTime` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '死亡时间',\n" +
            "  `MaritalStatus` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '婚姻状况',\n" +
            "  `YHFL` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '已婚分类',\n" +
            "  `Religious` char(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '宗教信仰',\n" +
            "  `Health` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '健康状况',\n" +
            "  `CYZK` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '从业状况',\n" +
            "  `Profession` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '职业',\n" +
            "  `BloodType` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '血型',\n" +
            "  `BYQK` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '兵役情况',\n" +
            "  `SHJZ` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '社会兼职',\n" +
            "  `gzdw` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '工作单位',\n" +
            "  `SpecialHobby` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '兴趣爱好',\n" +
            "  `StateId` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '居民状况',\n" +
            "  PRIMARY KEY (`Id`) USING BTREE\n" +
            ") ENGINE = InnoDB AUTO_INCREMENT = 3357 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '人员表' ROW_FORMAT = Dynamic;\n" +
            "\n" +
            "\n" +
            "CREATE TABLE `t_#communityCode#_person_service`  (\n" +
            "  `id` int(11) NOT NULL AUTO_INCREMENT,\n" +
            "  `personid` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',\n" +
            "  `serviceid` int(11) NULL DEFAULT NULL,\n" +
            "  PRIMARY KEY (`id`) USING BTREE\n" +
            ") ENGINE = InnoDB AUTO_INCREMENT = 1427 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;\n" +
            "\n" +
            "\n" +
            "CREATE TABLE `t_#communityCode#_person_state`  (\n" +
            "  `Id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Id',\n" +
            "  `PersonId` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT 'PersonId',\n" +
            "  `StateId` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',\n" +
            "  PRIMARY KEY (`Id`) USING BTREE,\n" +
            "  INDEX `idx_pstateid`(`StateId`) USING BTREE,\n" +
            "  INDEX `idx_ps_pid_#communityCode#`(`PersonId`) USING BTREE\n" +
            ") ENGINE = InnoDB AUTO_INCREMENT = 17025 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '人员民情状况' ROW_FORMAT = Dynamic;\n" +
            "\n" +
            "\n" +
            "CREATE TABLE `t_#communityCode#_procreate`  (\n" +
            "  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',\n" +
            "  `communityId` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '社区Id',\n" +
            "  `idCardType` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '证件类型',\n" +
            "  `idCard` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '申请人证件号',\n" +
            "  `applicantName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '声请人姓名',\n" +
            "  `applicantPhone` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '申请人电话',\n" +
            "  `applicantAddress` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '申请人住址',\n" +
            "  `householdcategory` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '户籍类别',\n" +
            "  `householdaddress` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '户籍地址',\n" +
            "  `applicationDate` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '申请日期',\n" +
            "  `acceptance` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '受理人',\n" +
            "  `processingState` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '处理状态',\n" +
            "  `acceptedDate` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '受理日期',\n" +
            "  `affairType` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '事项类别',\n" +
            "  `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '备注',\n" +
            "  `replyContent` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '回馈内容',\n" +
            "  PRIMARY KEY (`id`) USING BTREE\n" +
            ") ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '计生事项表' ROW_FORMAT = Dynamic;\n" +
            "\n" +
            "\n" +
            "CREATE TABLE `t_#communityCode#_remind`  (\n" +
            "  `id` int(11) NOT NULL AUTO_INCREMENT,\n" +
            "  `personid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '人员id',\n" +
            "  `content` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '通知内容(字典)',\n" +
            "  `situation` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '通知情况(字典)',\n" +
            "  PRIMARY KEY (`id`) USING BTREE\n" +
            ") ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;\n" +
            "\n" +
            "\n" +
            "CREATE TABLE `t_#communityCode#_service`  (\n" +
            "  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',\n" +
            "  `Time` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '服务日期',\n" +
            "  `Name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '服务名称',\n" +
            "  `Type` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '事项分类',\n" +
            "  `ServicePerson` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '服务人员',\n" +
            "  `Photo1` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '相关照片1',\n" +
            "  `Photo2` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '相关照片2',\n" +
            "  `Photo3` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '相关照片3',\n" +
            "  `Remark` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '备注',\n" +
            "  `createtime` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '创建时间',\n" +
            "  `updatetime` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '修改时间',\n" +
            "  `starttime` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '开始时间',\n" +
            "  `endtime` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '结束时间',\n" +
            "  `serviceLocalhost` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '服务地点',\n" +
            "  PRIMARY KEY (`id`) USING BTREE\n" +
            ") ENGINE = InnoDB AUTO_INCREMENT = 1302 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '服务事项' ROW_FORMAT = Dynamic;\n" +
            "\n").append(
            "\n" +
            "CREATE TABLE `t_#communityCode#_smsmessage`  (\n" +
            "  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',\n" +
            "  `msgId` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '短信发送成功短信平台返回的ID',\n" +
            "  `addresser` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '发件人',\n" +
            "  `theme` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '短信主题',\n" +
            "  `content` varchar(800) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '短信内容',\n" +
            "  `sendDate` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '发送时间',\n" +
            "  `sendStatus` int(10) NULL DEFAULT NULL COMMENT '发送状态：\\n            0：删除；1：已发送；2：定时短信；3：草稿；4：发送中',\n" +
            "  `total` int(10) NULL DEFAULT 0 COMMENT '冗余字段：发送短信收件人的总数量',\n" +
            "  `sended` int(10) NULL DEFAULT 0 COMMENT '冗余字段：已发送数量',\n" +
            "  `success` int(10) NULL DEFAULT 0 COMMENT '冗余字段：短信成功发送数量',\n" +
            "  `fail` int(10) NULL DEFAULT 0 COMMENT '冗余字段：短信发送失败数量',\n" +
            "  PRIMARY KEY (`id`) USING BTREE\n" +
            ") ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '短信表' ROW_FORMAT = Dynamic;\n" +
            "\n" +
            "\n" +
            "CREATE TABLE `t_#communityCode#_smssendreport`  (\n" +
            "  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',\n" +
            "  `msgId` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '短信发送成功短信平台返回的ID',\n" +
            "  `personName` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '收件人',\n" +
            "  `telephone` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '收件号码',\n" +
            "  `labelName` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '标签名',\n" +
            "  `status` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '短信发送状态',\n" +
            "  `reportTime` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '发送时间',\n" +
            "  PRIMARY KEY (`id`) USING BTREE\n" +
            ") ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '发件箱' ROW_FORMAT = Dynamic;\n" +
            "\n" +
            "\n" +
            "CREATE TABLE `t_#communityCode#_socialsecurity`  (\n" +
            "  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',\n" +
            "  `communityId` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '社区Id',\n" +
            "  `idCardType` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '证件类型',\n" +
            "  `idCard` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '申请人证件号',\n" +
            "  `applicantName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '声请人姓名',\n" +
            "  `applicantPhone` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '申请人电话',\n" +
            "  `applicantAddress` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '申请人住址',\n" +
            "  `securityType` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '事项类型',\n" +
            "  `applicationDate` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '申请日期',\n" +
            "  `acceptance` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '受理人',\n" +
            "  `processingState` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '处理状态',\n" +
            "  `acceptedDate` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '受理日期',\n" +
            "  `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '备注',\n" +
            "  `replyContent` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '回馈内容',\n" +
            "  PRIMARY KEY (`id`) USING BTREE\n" +
            ") ENGINE = InnoDB AUTO_INCREMENT = 59 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '社保事务表' ROW_FORMAT = Dynamic;\n" +
            "\n" +
            "\n" +
            "CREATE TABLE `t_#communityCode#_specialcare`  (\n" +
            "  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',\n" +
            "  `personId` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',\n" +
            "  `specialCareType` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '优抚类别',\n" +
            "  `disableCard` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '残疾证号',\n" +
            "  `causeOfDisability` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '致残原因',\n" +
            "  `emergencyContact` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '紧急联系人',\n" +
            "  `emergencyPhone` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '紧急联系人电话',\n" +
            "  `injuredPart` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '伤部',\n" +
            "  `remark` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '备注',\n" +
            "  PRIMARY KEY (`id`) USING BTREE\n" +
            ") ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '优抚对象' ROW_FORMAT = Dynamic;\n" +
            "\n" +
            "\n" +
            "CREATE TABLE `t_#communityCode#_specialpension`  (\n" +
            "  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',\n" +
            "  `personId` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT 'PersonId',\n" +
            "  `specialPensionType` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '扶助类型',\n" +
            "  `isNongZhuanFei` int(11) NULL DEFAULT 1 COMMENT '是否是农转非',\n" +
            "  `isHavePension` int(11) NULL DEFAULT 1 COMMENT '是否有退休金',\n" +
            "  `annualIncome` int(11) NULL DEFAULT 0 COMMENT '家庭年收入',\n" +
            "  `familyProfile` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '家庭简要情况',\n" +
            "  `pensionData` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '享受帮扶时间',\n" +
            "  `pensionDept` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '享受帮扶部门',\n" +
            "  `pensionContent` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '享受帮扶内容',\n" +
            "  `idCardValidDate` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '证件有效期',\n" +
            "  `issuingOrgan` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '发证机关',\n" +
            "  `bankHuiminAccount` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '银政惠民账号',\n" +
            "  `zipCode` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '邮编',\n" +
            "  `remark` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '备注',\n" +
            "  PRIMARY KEY (`id`) USING BTREE\n" +
            ") ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '人员状态扩展信息（特别扶助）' ROW_FORMAT = Dynamic;\n" +
            "\n" +
            "\n" +
            "CREATE TABLE `t_#communityCode#_state`  (\n" +
            "  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',\n" +
            "  `name` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '名称',\n" +
            "  `url` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '图片路径',\n" +
            "  `sort` int(4) NULL DEFAULT 0 COMMENT '排序',\n" +
            "  `code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '编号',\n" +
            "  PRIMARY KEY (`id`) USING BTREE\n" +
            ") ENGINE = InnoDB AUTO_INCREMENT = 264 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;\n" +
            "\n" +
            "\n" +
            "CREATE TABLE `t_#communityCode#_sys_logs`  (\n" +
            "  `id` int(30) NOT NULL AUTO_INCREMENT COMMENT 'id',\n" +
            "  `opername` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '操作名称',\n" +
            "  `opercode` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '操作编码',\n" +
            "  `content` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '操作内容',\n" +
            "  `type` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '分类',\n" +
            "  `sessionid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '会话ID',\n" +
            "  `username` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '用户名、操作人',\n" +
            "  `realname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '真实姓名',\n" +
            "  `url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT 'url',\n" +
            "  `ip` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',\n" +
            "  `clazz` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '类名',\n" +
            "  `method` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '方法名',\n" +
            "  `returnMsg` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '方法返回值',\n" +
            "  `createtime` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '创建时间',\n" +
            "  `remark` varchar(600) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',\n" +
            "  PRIMARY KEY (`id`) USING BTREE\n" +
            ") ENGINE = InnoDB AUTO_INCREMENT = 25398 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '日志表' ROW_FORMAT = Dynamic;\n" +
            "\n" +
            "\n" +
            "CREATE TABLE `t_#communityCode#_telephonebook`  (\n" +
            "  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',\n" +
            "  `personId` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '人员id',\n" +
            "  `idcard` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '证件号码',\n" +
            "  `fixQhone` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '固定电话',\n" +
            "  `telephone` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '手机号码',\n" +
            "  PRIMARY KEY (`id`) USING BTREE\n" +
            ") ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '短信发送通讯录' ROW_FORMAT = Dynamic;\n" +
            "\n" +
            "\n" +
            "CREATE TABLE `t_#communityCode#_template`  (\n" +
            "  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',\n" +
            "  `isUpDown` int(11) NULL DEFAULT 0 COMMENT '上下联标记',\n" +
            "  `title` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '模板标题',\n" +
            "  `organization` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '称谓',\n" +
            "  `NAME` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '证明人姓名',\n" +
            "  `address` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '居住地址',\n" +
            "  `householdaddress` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '户籍地址',\n" +
            "  `idCard` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '证明人证件号码',\n" +
            "  `age` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '证明人年龄',\n" +
            "  `sex` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '证明人性别',\n" +
            "  `ending` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '证明结尾',\n" +
            "  `templatePurpose` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '证明用途',\n" +
            "  `templateDate` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '落款日期',\n" +
            "  `organizationName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '落款单位',\n" +
            "  `instructions` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '模板说明',\n" +
            "  `templateUrl` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '模板URL',\n" +
            "  `producer` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '创建人',\n" +
            "  `productionDate` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '创建日期',\n" +
            "  `effectiveness` int(5) NULL DEFAULT 1 COMMENT '有效性',\n" +
            "  `content` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '补充内容',\n" +
            "  `code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,\n" +
            "  PRIMARY KEY (`id`) USING BTREE\n" +
            ") ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '模板表' ROW_FORMAT = Dynamic;\n" +
            "\n").append(
            "\n" +
            "CREATE TABLE `t_#communityCode#_underground`  (\n" +
            "  `id` int(11) NOT NULL AUTO_INCREMENT,\n" +
            "  `buildingId` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',\n" +
            "  `houseCoding` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',\n" +
            "  `address` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',\n" +
            "  `area` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',\n" +
            "  `company` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '管理单位',\n" +
            "  `phone` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',\n" +
            "  `underType` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',\n" +
            "  `spaceCondition` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '空间状况',\n" +
            "  `remark` varchar(600) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',\n" +
            "  `floor` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '楼层',\n" +
            "  PRIMARY KEY (`id`) USING BTREE\n" +
            ") ENGINE = InnoDB AUTO_INCREMENT = 35 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;\n" +
            "\n" +
            "\n" +
            "CREATE TABLE `t_#communityCode#_volunteer`  (\n" +
            "  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',\n" +
            "  `personId` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '人员主表ID',\n" +
            "  `volunteerID` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '志愿者编号',\n" +
            "  `yearServiceHours` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '今年服务时长',\n" +
            "  `serviceHours` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '累计服务时长',\n" +
            "  `remark` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '备注',\n" +
            "  `createDate` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '创建日期',\n" +
            "  PRIMARY KEY (`id`) USING BTREE\n" +
            ") ENGINE = InnoDB AUTO_INCREMENT = 76 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '志愿者扩展信息表' ROW_FORMAT = Dynamic;\n" +
            "\n" +
            "\n" +
            "CREATE TABLE `t_#communityCode#_yulingfunv`  (\n" +
            "  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',\n" +
            "  `personId` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',\n" +
            "  `zhuXiaoStatus` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '注销状态',\n" +
            "  `firstMarriage` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '初婚日期',\n" +
            "  `nowNumberOfChildren` int(11) NULL DEFAULT NULL COMMENT '现生子女数',\n" +
            "  `ownedNumberOfChildren` int(11) NULL DEFAULT NULL COMMENT '曾生子女数',\n" +
            "  `contraception` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '避孕状况',\n" +
            "  `remark` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '备注',\n" +
            "  PRIMARY KEY (`id`) USING BTREE\n" +
            ") ENGINE = InnoDB AUTO_INCREMENT = 1121 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '育龄妇女' ROW_FORMAT = Dynamic");
    private String streettable ="CREATE TABLE `t_#streetCode#_buildingcount`  (\n" +
            "  `communityid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '社区id',\n" +
            "  `communityname` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '社区名称',\n" +
            "  `yardcount` int(11) NULL DEFAULT NULL COMMENT '数量',\n" +
            "  `buildingcount` int(11) NULL DEFAULT NULL COMMENT '数量',\n" +
            "  PRIMARY KEY (`communityid`) USING BTREE\n" +
            ") ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;\n" +
            "\n" +
            "\n" +
            "CREATE TABLE `t_#streetCode#_community`  (\n" +
            "  `id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'id',\n" +
            "  `StreetId` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '所属街道',\n" +
            "  `CommunityName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '社区名称',\n" +
            "  `systemIcon` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '社区图标',\n" +
            "  `systemName` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '平台名称',\n" +
            "  `borderId` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',\n" +
            "  `nameObjectId` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',\n" +
            "  PRIMARY KEY (`id`) USING BTREE\n" +
            ") ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '社区' ROW_FORMAT = Dynamic;\n" +
            "\n" +
            "\n" +
            "CREATE TABLE `t_#streetCode#_householdcount`  (\n" +
            "  `communityid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '社区id',\n" +
            "  `communityname` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '社区名称',\n" +
            "  `householdcount` int(11) NULL DEFAULT NULL COMMENT '数量',\n" +
            "  `realholdcount` int(11) NULL DEFAULT NULL COMMENT '数量',\n" +
            "  PRIMARY KEY (`communityid`) USING BTREE\n" +
            ") ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;\n" +
            "\n" +
            "CREATE TABLE `t_#streetCode#_householdstatuscount`  (\n" +
            "  `communityid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '社区id',\n" +
            "  `communityname` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '社区名称',\n" +
            "  `householdstatuscode` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '户籍状态code',\n" +
            "  `householdstatus` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '户籍状态',\n" +
            "  `statecount` int(11) NULL DEFAULT NULL COMMENT '数量',\n" +
            "  PRIMARY KEY (`communityid`, `householdstatuscode`) USING BTREE\n" +
            ") ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;\n" +
            "\n" +
            "\n" +
            "CREATE TABLE `t_#streetCode#_housestate`  (\n" +
            "  `communityid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '社区id',\n" +
            "  `communityname` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '社区名称',\n" +
            "  `housestate` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '房屋状态code',\n" +
            "  `statename` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '房屋状态',\n" +
            "  `statecount` int(11) NULL DEFAULT NULL COMMENT '数量',\n" +
            "  PRIMARY KEY (`communityid`, `housestate`) USING BTREE\n" +
            ") ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;\n" +
            "\n" +
            "CREATE TABLE `t_#streetCode#_managedepartment`  (\n" +
            "  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',\n" +
            "  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '名称',\n" +
            "  `linkman` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '联系人',\n" +
            "  `phone` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '联系方式',\n" +
            "  PRIMARY KEY (`id`) USING BTREE\n" +
            ") ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;\n" +
            "\n" +
            "\n" +
            "CREATE TABLE `t_#streetCode#_personstate`  (\n" +
            "  `communityid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '社区id',\n" +
            "  `communityname` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '社区名称',\n" +
            "  `personstate` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '人员状态code',\n" +
            "  `statename` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '人员状态',\n" +
            "  `statecount` int(11) NULL DEFAULT NULL COMMENT '数量',\n" +
            "  PRIMARY KEY (`communityid`, `personstate`) USING BTREE\n" +
            ") ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;\n" +
            "\n" +
            "\n" +
            "CREATE TABLE `t_#streetCode#_sexcount`  (\n" +
            "  `communityid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '社区id',\n" +
            "  `communityname` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '社区名称',\n" +
            "  `mancount` int(11) NULL DEFAULT NULL COMMENT '数量',\n" +
            "  `womancount` int(11) NULL DEFAULT NULL COMMENT '数量',\n" +
            "  PRIMARY KEY (`communityid`) USING BTREE\n" +
            ") ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;\n" +
            "\n" +
            "CREATE TABLE `t_#streetCode#_sys_logs`  (\n" +
            "  `id` int(30) NOT NULL AUTO_INCREMENT COMMENT 'id',\n" +
            "  `opername` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '操作名称',\n" +
            "  `opercode` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '操作编码',\n" +
            "  `content` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '操作内容',\n" +
            "  `type` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '分类',\n" +
            "  `sessionid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '会话ID',\n" +
            "  `username` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '用户名、操作人',\n" +
            "  `realname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '真实姓名',\n" +
            "  `url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT 'url',\n" +
            "  `ip` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',\n" +
            "  `clazz` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '类名',\n" +
            "  `method` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '方法名',\n" +
            "  `returnMsg` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '方法返回值',\n" +
            "  `createtime` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '创建时间',\n" +
            "  `remark` varchar(600) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',\n" +
            "  PRIMARY KEY (`id`) USING BTREE\n" +
            ") ENGINE = InnoDB AUTO_INCREMENT = 299 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '日志表' ROW_FORMAT = Dynamic";


    public List<String> getCommunitySqlList(String code){
        String commtableSql = communitytable.toString();
        commtableSql = commtableSql.replaceAll("#communityCode#",code);
        List<String> sqllist = Arrays.asList(commtableSql.split(";"));
        return sqllist;
    }

    public List<String> getStreetSqlList(String code){
        streettable = streettable.replaceAll("#streetCode#",code);
        List<String> sqllist = Arrays.asList(streettable.split(";"));
        return sqllist;
    }


}
